package cn.smbms.dao.bill;

import java.sql.Connection;
import java.util.List;

import cn.smbms.pojo.Bill;

public interface BillDao {
 // 增加订单
	public boolean add(Connection connection,Bill bill)throws Exception;
	//通过查询条件获取供应商列表-模糊查询
  public List<Bill> getBillList(Connection connection,Bill bill,int pageIndex,int pageSize)throws Exception;
 //通过delId删除Bill
	public boolean deleteBillById(Connection connection,String delId)throws Exception; 
	//通过billId获取Bill
	public Bill getBillById(Connection connection,String id)throws Exception; 
    // 修改订单信息
	public boolean modify(Connection connection,Bill bill)throws Exception;
    //根据供应商ID查询订单数量
	public int getBillCountByProviderId(Connection connection,String providerId)throws Exception;
	// 查询总数量
			public int getCounts(Connection connection,Bill bill) throws Exception;


}
